﻿if exists (select * from dbo.sysobjects where name = 'sp_Departments_Delete')	drop procedure [dbo].[sp_Departments_Delete]Go CREATE PROCEDURE dbo.sp_Departments_Delete	@dpID		intAS	DELETE FROM [Departments]	 WHERE dpID = @dpIDGo 